Hire freelance Etl

Find and hire skilled Etl freelancers with Wono and get work done on a secure and flexible community-driven platform.
Browse top 19 freelancers by category - to view all resumes click:
Adisan Patel
BASIC
SQL Developer Adisan Patel, Websites, IT & Software
• 15+ years of IT experience in Data Design and Development on Microsoft SQL Server 2017/2014/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing. • Experience using SQL Server Management Studio (SMS), SQL Reporting Services (SSRS), and SQL Server Integration Service (SSIS). • Strong conceptualization, problem-solving, and analytical skills. • Ability to work closely with business customers, analysts, and developers as part fast-paced environment being a team player while capable of working independently. • Ability to effectively interface and collaborate with non-IT teams across the organization. • Ability to verbalize and communicate technical issues to non-technical audiences. • Experience working with remote resources. • Ability to think strategically and be innovative in a team-oriented environment. • Strong critical thinking, decision making and problem-solving skills as well as excellent interpersonal skills. • Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2017/2019. • Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity. • Extensive knowledge of Normalization and Relational Database Management Systems. • Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2017/2014/2012. • Great ability to create and manage various database objects like tables, views. • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. • Experience in Performance Tuning and Query Optimization. • Experienced in using ETL tools in (SSIS) MS SQL 2017, MS SQL 2014 and DTS in MS SQL 2000 • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. • Data Loading Experience in SQL Server 2017 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task. • Data analysis and data migration by transferring them using SSIS packages. • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). • Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. • Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler. • Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Capable of forming and maintaining positive and productive working relationships in internal/external and team environments. • Exposure on Data visualization tools like Tableau, QlikView, Microsoft Power BI, Elegant JBI
Websites, IT & Software
Database Development
Database Programming
ETL
Tableau
25 $
Ashish K
BASIC
SQL BI Developer Ashish K, Websites, IT & Software
Ashish linkedin.com/in/ashish-kaushik-833338191 Certified SQL BI (SSIS/SSRS/SSAS/Power BI) Consultant PROFESSIONAL SUMMARY: • Around 6+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2012/2014/2016/2017 in Development, Test and Production Environments. • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013/2016 Performance Point Server and ProClarity analysis server. • Experience in Developing and Tuning T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks • Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems • Implemented Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions. • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2/2012,2014,2015,2016). • Thorough understanding of Kimball’s’ theory, KPIs, Perspectives, Translations and SQL 2008 Architecture. • Experience with data modeling, logical and physical database design using Erwin. • Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012/2014. • Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008R2/2012/2014, Powerpivot(Excel 2010) • Designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes. • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report). • Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012. • Experienced in using Power Shell / Power BI. • Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, Oracle, Teradata, flat file) by using multiple transformations provided by SSIS like Data Conversion, Conditional Split, Bulk Insert, merge, union all. • Developed data interface layer using ASP.NET and C# for data access. • Worked in performance tuning, query optimization, client/server connectivity and Database Consistency Checks using DBCC utilities. • Developing reports on SSAS & SSRS on SQL Server (2000/2005/2008/2008 R2/2012/2014/2016). Experience and understanding of SSAS, OLAP cube and Architecture. • Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications. • Expertise in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot. EDUCATION: Master of Engineering Mechanical Engineering Rochester Institute of Technology, NY Bachelor of Engineering Mechanical Engineering GGSIPU, Delhi, India. TECHNICAL SKILLS: Databases SQL Server 2014/2012/2008/2008R2/2005, Oracle 8i/9i/10g/11g, MYSQL Database Tools SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD. Reporting Tools SSRS, Report Builder, Focus, Power BI. Languages T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA OLAP SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI Change Management Tool Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS) Operating Systems Windows Server 2000/2003/2008/2012, MS DOS, Unix, Linux. PROFESSIONAL EXPERIENCE: Experience: FirstCare Health Plans, Austin, TX Oct 2018 – Till date Power BI Developer Responsibilities: • Deliver high quality, innovative BI solutions in a fast-paced environment • Data mining and modeling, regression analysis, process documentation, profitability analysis, lead/list generation, customer attrition and direct mail campaign analysis • Responding to requests from partners for customer information reports, lists etc. • Identifying/recommending potential data sources. • Responsible for performing assigned database-related analyses and projects. • Ensures adherence to compliance regulations and policies. • Design and develop ETL solutions for multiple source systems • Design, develop, and support BI-related database applications spanning multiple lines of business • Evaluate operation of production BI applications/environments and perform appropriate troubleshooting as necessary • Worked on Office 365 SharePoint Modern site collections. • Created SSIS packages from scratch to perform ETL process and loaded the data into destination table. • Implemented Error Handling, Isolation Levels, Precedence Constraints, and Expressions in SSIS packages. • Calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL. • Perform complex data analysis to identify trends, patterns, and opportunities • Collaborate effectively with Engineers, Product Managers, and Project Managers to implement project deliverables. • Worked in the QNXT . • Configured match ruleet property by enabling search by rules in MDM according to Business Rules. • Effectively work with business users to determine project requirements and issues • Create and maintain technical documents • Configure and maintain test environments. • Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, KPI’s in power BI reports. • Extensively involved in creating robust complex power BI models, writing complex DAX logic’s involving rank, filters and data massaging. • Created advanced chart types, visualizations and complex calculations to manipulate the data. • High-priority issue handling (hot-fixes). • Application, functionality and product sign-offs for release and release tracking. • Create and maintain system documentation. • Performed regression testing for fixes using QTP and closed the defects in Test Manager. Involved in the end-to-end test using QTP and responsible for the Quality-Assurance of this application to complete in record time. • Attend Project/Daily-Scrum meetings. • Plan and execute system end-to-end tests for all existing and new applications. • Participate in system integration testing with other teams. • Participate in integration testing with clients/3rd party vendors. • Build regression test suite and plan/execute regression tests as needed. Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, QTP, J Unit, Selenium and Excel. Thomson Reuters, Rochester, NY April-2018 – Oct 2018 SSRS Developer Thomson Reuters is one of the world’s most trusted provider of answers, helping professionals make confident decisions and run better businesses. Responsibilities: • Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments. • Automated SharePoint 2016 Farm build. • Extracting and transforming data within Business Intelligence environment. • Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages. • Designed and developed SQL programming objects, including stored procedures, user defined functions, and common table expressions • Used Performance Point Server (PPS)to create interactive reports with an ability to drill down into details • Perform unit level analysis on all work done before handing over to the testing team • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic • Create SSRS reports according to user requirements and technical standards • Customize output formats from SSRS to Excel, PDF, and CSV. • Creating Report-Models for ad-hoc reporting and analysis. • Developed Query for generating drill down reports in SSRS 2008 R2 • SQL Server 2008 Reports Writer and performed complex SQL report writing and design. • Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio. • Built multiple data visualizations using Power BI in the form of interactive reports and dashboards; delivered different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps etc. • Worked with Power BI Desktop workbooks and data models that are created using Data Analysis Expressions (DAX) Prepared Dashboard reports and presenting it to the concern team. • Published Power BI Desktop reports created in Report view to the Power BI service. • Utilized DAX functions/query which includes Aggregation, Counting, Logical, information, Text and date functions in source data. • Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards. • Worked on data cleansing using the cleanse functions in Informatica MDM. • Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS • Writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services SSAS 2005/2008/2208R2. • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity. • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports, • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012. Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel. Immense Analytics. Rochester, NY Sept 2017- Mar 2018 SQL BI (SSIS) Developer Immense Analytics has partnered with DataGravity to bring their data-aware storage platform to clients. Immense Analytics offers installation, configuration and maintenance of their award-winning products. Responsibilities: • Delivered high quality, innovative BI solutions in a fast-paced environment • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application. • Designed and developed ETL solutions for multiple source systems • Designed, developed and supported BI-related database applications spanning multiple lines of business with loan and leasing applications. • Performed complex data analysis to identify trends, patterns, and opportunities • Created SSIS packages to extract, load and transform the data from flat files to database tables, API to database • Extensively for the Pre-Prime product team • Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default. • Experience in performance tuning, query optimization, Database Maintenance plans • Performed Unit & IT testing& conducted UAT sessions with end users. • Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations. • Use Cosmos products in developing internal applications and presentations. • Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries on SQL Server 2012/2014. • Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer. • Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle DB, SQL DB, MS Azure. • Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base. • Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables. • Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc. • Excellent in creating reports with SQL Server Reporting Services (SSRS) and Power BI • Used SSRS and power BI to create reports, Parameterized Reports, Drill down & Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. • Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures. • Provided reporting and analytic solutions to the organization in the form of Reporting Services reports and Analysis Services cubes. • Using the above query results from Cosmos, creating reports in PowerBI, Ads pulse to show the metrics by server and procedure name, by server etc. • Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis • Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval. • Involved in performance tuning of SSIS Packages. Environment: SQL Server 2016/2014/2012, OLTP, Informatica 9.1, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power Shell, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel. Kartrocket (Shiprocket 360), Gurgaon, India July 2015- July 2017 SQL Developer Shiprocket 360 is an end to end commerce enablement solution which helps offline and online retailers build their omnichannel solution. Shiprocket 360 helps to create a seamless journey for customers across all sales channels based on their interest, reaction, and past interactions. Responsibilities: • Involved in migration of SQL Server 2008 to 2012/2014. • SQL Server 2008 Reports Writer and performed complex SQL report writing and design. • Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio. • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity. • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports, • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012. • Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed. • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS. • Defined best practices for Tableau report development. • Defined best practices for Tableau report development and effectively used data blending feature in tableau. • Create Master Package to run different other ETL in one Master package. • Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages. • Bug fixes in SSIS, SSRS and stored procedures as necessary. • Perform T-SQL tuning and optimizing queries for and SSIS packages. • Created SSIS process design architecting the flow of data from various sources to target. • Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS Environment: SQL Server 2014/2012/2008R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Tableau, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle. Zostel, New Delhi, India Aug 2013 – June 2015 Jr. Developer (SSIS, SSRS) Zostel is one of the largest networks of backpackers' hostels founded in India, and one of the country's first. The chain of hostels has presence across 36 locations in India and Nepal Responsibilities: • Involved in complete Software Development Life Cycle (SDLC). • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files. • Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008. • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production). • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc. • Implemented Event Handlers and Error Handling in SSIS packages. • Created SSIS packages for Data Conversion using data conversion transformation. • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse. • Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function. • Use Window azure to deploy the application on cloud and managing the session. Worked on Azure Data Factory for Extract & Load data. • Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager. • Experience on extracting data from Azure HDInsight and publish the transformed data into AzureSQL Data Warehouse and build reports on BI platform. • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema. • Calculated measures and dimension members using multi-dimensional expression (MDX). • Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube. • Created reports using stored procedure and Experience in building Reports on Analysis Services cubes. • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS). • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS). • Developed a High level dashboard using SSRS 2008. • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008. • Involved in upgrading from SQL Server 2005 to SQL Server 2008. • Responsible for writing T-SQL code for creating cursor and handling data validations. Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.
Websites, IT & Software
ETL
NoSQL
Power BI
SQL
SSIS (SQL Server Integration Services)
57 $
Atam Govil
BASIC
IT Project Manager Atam Govil, Websites, IT & Software
• PMP, PSM and ITIL Expert Certified, Dynamic, hands on Program/Project Manager with more than 10 years of experience in driving business initiatives and leading effective teams for global enterprise customers. Have successfully adapted PMI, Agile and ITIL guidelines and standards to adhere with projects and business needs. Implemented measurable KPI for continuous improvements of teams and the portfolio. • Led program/projects using Agile development methodology – motivate, organized and mentored scrum teams at global level. Align velocity, prioritize stories with PO and report burn down/up charts to management levels. • Ability to envision the "big picture" and interact with executive, business, and functional leadership to materialize business strategies. Thrive in dynamic and chaotic environments. • A strong communicator and negotiator with a flair for building positive and collaborative relationships, as well as trust between teams and clients. Have managed projects through their full life-cycle, transitioning of services, interfacing successfully with business stakeholders, vendors, customer’ customers and technical/operational teams • Experienced in financial accounting, Revenue Recognition, P&L manage, billing and utilization in line with Organization and project goal. Budget management, revenue margins, PM margin levers and plan delivery unit growth. • Strong technical experience to provide best mix of technical and management experience in supporting end to end customer business requirements.
Websites, IT & Software
Agile Project Management
Informatica Powercenter ETL
J2EE
Oracle Database
RESTful API
60 $
Willie Li
BASIC
SQL Developer - remote Willie Li, Websites, IT & Software
SUMMARY OF QUALIFICATIONS • Strong business analytical skills, outstanding business knowledge in Finance, Insurance, Healthcare, Ecommerce, Retail and Media. • Excellent database/data warehouse design and administration, data transformation and data analysis expertise. • Solid full life cycle business application development experience. • Great background in Computer Science, Mathematics and Statistics. • Seasoned object-oriented/Web/E-Commerce/Window application programming and problem-solving experience. COMPUTER SKILLS: • Languages: C#, ASP/ASP.NET, SQL, PL/SQL/T-SQL, Python, PowerShell, VBScript/JavaScript/jQuery/CSS/SCSS/XSL, Visual Basic, C/C++, Java, XML/JSON/HTML/DHTML, Ajax, PHP • Database: MS SQL Server (from SQL 6.5 to SQL 2017), Redshift, MySQL, Oracle, MS Access, DB2, Firebird, MongoDB • Software/Tool: Visual Studio, SQL Server SSIS/SSRS/SSAS, SSMS/Azure Data Studio, SQL Workbench, MS Power BI, Tableau, Crystal Reports, Elasticsearch/Kibana, ER/Studio Data Architect, MS Office/FrontPage/PowerPoint/Share Point, Visual Source Safe, Agile, Bitbucket/Git, Jira, ZappSys, Magneto, Fishbowl, Shipworks PROFESSIONAL EXPERIENCE Radiological Society of North America (Oak brook, IL) SQL /ETL Developer 04/2019-Present Work closely with business user and application developer to analyze/enhance the existing relational/non-relational database solution, create new database solution, redesign the data warehouse to better serve the business. • Highly proficient in T-SQL programming, create/update complex stored procedure, user defined function/type, view, trigger and index on SQL Server, improve the query performance, decrease the CPU usage and disk IO. • Create/enhance ETL packages to auto retrieve data from FTP server, dynamic web page and different API call, transform data from different format to relational data, store the transformed data to Redshift and SQL database. Store and manage data files in Amaze S3. • Use SSRS/Power BI to build customized interactive/parameterized/drill down reports and dashboard. • Create ETL project to update company level Elasticsearch data. • Design and develop ETL solution using SSIS/C# to read and reformat special survey data for business reporting. • Create ETL solution using SSIS/Python to read vendor data file, fix the input data issue and transfer the data for analysis needs. • Redesign the data warehouse schema, improving the loading data job’s efficient, decrease job’s running time. • Create and maintain varies daily/weekly/monthly SQL Server Agent jobs. These jobs are used to prepare and transform data from different source to SQL database and enterprise data warehouse. • Set up a new SQL ETL development server, create new SQL Server Agent jobs. Unique Fitness Concepts (Vermont Hills, IL) Senior Developer/Data Analyst 03/2017 – 04/2019 Interact with business user to define the requirements for business need. Work with different software vendors to customize their solution to fit Unique Fitness’s need. Use SSIS/C# to build ETL tools to integrate data from different sources. Enhance and support Unique Fitness’s web site, troubleshoot site related issues. • Created, maintained and updated email, invoice, label and packing slip templates in Shipworks. • Maintained and updated Unique Fitness website using Magento software. • Monitored, cleansed and mapped more than 100 vendors' product and price data source. • Designed and developed ETL solution using SSIS/C# to maintain product and pricing. • Used SSRS/Power BI to generate reports to satisfy business needs. Li & Association (Westmont, IL) Consultant 09/2004 - 03/2017 Built business solution for different clients. • Designed, created and maintained a stock trade analytical tool. Developed a ETL tool to auto retrieve market data from different web sites. Built and maintained a SQL server database to store trade and market data, generated different trend reports for business user. • Designed and developed different solutions to help client monitoring/cleansing/mapping/integrating healthcare data. • Designed, created and enhanced business reports for different clients. Bank One/JPMorgan Chase (Chicago, IL) Senior Developer /DBA 08/2002 - 08/2004 Worked with Bank One capital marketing business supervisor, designed and built applications/database to achieve SuperBase model (fix income prepayment modeling), created industrial recognized software and reports. • Designed, created, maintained and fine-turning SQL Server database and managed the database security. There are more than 100 GB data in 11 databases, more than 300 stored procedures and 50 DTS and jobs to implement the business rules. • Processed the loan level data received from six different issuers, pool level data from Intex to produce the data for SuperBase application. • Built and enhanced SuperBase application. This is an analysis tool used to analyze loan level (current and future) and pool level (current) data. It also generated monthly residential ABS reports, loan forecast data (ARM and Fixed), on-demanding reports/data required by business users and clients. • Built a data warehouse using SuperBase monthly report’s results and marketing data. • Built SuperBase client software to allow client analyzing their loan information and generating forecast data based on the marketing information. • Created Microsoft Word templates used for monthly reports. Tellabs (Lisle, IL) Consultant (Web Developer) 10/2001- 05/2002 • Enhanced and supported Detailed Specification System. The DSS software is an intranet application designed to increase the productivity of the deployment engineering group. Technium (Chicago, IL) Consultant 09/2000 – 08/2001 Designed and built applications for eSkye Solutions, Inc. (a service network and technology solutions provider for the global beverage industry) • As a web developer: built a web application allowing eSkye customer service setting up and maintaining user's profile and their priority on-line. • As a SQL server developer: mapped data between existing data structure and newly implement data structure, converted data from existing database and other sources to new database. Created and modified stored procedure, triggers, user defined functions and built DTS packages and jobs. Designed and built applications for RollingStone.com (an internet music distribution) • As a web developer: involved in the full life cycle development of client's system. Built a web-based administrator tool to allow user to change their data on-line. Created and modified COM components to add new functionalities. • As a SQL developer: created COM components to be used in SQL server jobs. Created and modified stored procedures, triggers, user defined functions and built DTS packages and jobs. Stargate Communications Inc. (Oak Brook, IL) Web Developer 03/2000 – 09/2000 Designed and built several applications for different client. • Sole responsible for building the B2B web site www.comm-2000.com. Worked with business owner to define the business need, created the database, designed and coded the web site. Used SQL DTS/Jobs to translate the product and client information between UL and www.comm-2000.com. • Enhanced www.mba2mba.com web site and its database. Coded most of the site functionality including member sign on/registration, colleague search and site administration functionality used to maintain member information on-line. • Used SQL Server, Crystal Report as the tools to sort and group the raw data from www.OurHouse.com and produced meaning reports for the client. Newspaper Services of American (Naperville, IL) Senior Developer 07/1998 – 03/2000 • Designed and built a client-server application to maintain the company’s vendor information. • Installed a new MS SQL Server. Designed and set up a new MS SQL Server database, converting the existing data into the newly created database. • Designed and built an interface application to map client’s data into NSA system. • Designed and coded company’s intranet application. NCH Promotional Service (Lincolnshire, IL) Developer 01/1997 – 07/1998 • Designed and modified current system (Batch and Front-end) to accomplish business changes. • Directly contacted manufacturers, obtained requests and completed tasks. • Supported current retailer system. Metamor Technologies (Chicago, IL) Consultant 06/1996 – 01/1997 Designed and built several applications for client United Healthcare of Chicago. • Created, reformed current system (batch process) to achieve client’s request • Communicated directly with clients, finished ad-hoc requests. • On call support. EDUCATION AND CERTIFICATE Master of Science Degree (Computer Science, Loyola University of Chicago, January 1994 - May 1996)
Websites, IT & Software
C# Programming
Database Development
ETL
Microsoft SQL Server
SSIS (SQL Server Integration Services)
60 $
Nilakshi Roy
BASIC
Data Analyst Nilakshi Roy, Websites, IT & Software
NILAKSHI ROY linkedin.com/in/nilakshi-roy/ | EDUCATION Master of Science in Computer Science | California State University, East Bay | GPA: 3.9/4.0 [Graduation Date: Dec 2021] Relevant Coursework: Operating systems, Database Management, Machine Learning, Statistics, Advanced Algorithms Master of Technology in Computer Science | Christ University, Bengaluru, India [Graduation Date: Mar 2016] Bachelor of Technology in Computer Science | WBUT, Kolkata, India [Graduation Date: Mar 2014] SKILLS Databases: MySQL, MongoDB (NoSQL Database). Programming Languages: Python,Java Python Tools: Scikit-Learn, Pandas, NumPy, Visualizations, Matplotlib. Tools: Tableau Desktop, MySQL Workbench, GitHub, Jupyter Notebook, R Studio(statistics). Machine Learning: Predictive models, Regression, Classification, Clustering. Cloud Technologies: Amazon Web Services (AWS) WORK EXPERIENCE Quality assurance member | Apple Inc., Cupertino, California, USA [Jun 2020 - Jan 2021] ● Supporting EFFA team on troubleshooting and performing FA (Failure Analysis) on iPad and iWatch IOS system. ● Performing functional automated tests of iOS devices. ● Perform bugs reporting and also tracking, and captured unit failures on Radar and FileMaker. ● Analyzing and reporting the test results of various hardware and software tests performed on iPhone and iWatch that are under development and pre-release and post-release ● Technologies: MySQL server, Numbers, Excel, Google sheets. Catastrophe Modeling Analyst | Data Stewardship| American International Group (AIG), Bengaluru, India [Aug 2016 - Jan 2019] ● Analyzing the risk & potential losses caused by any type of natural calamities from large volumes of data, finding out the patterns in the large data set, converting them in a proper format for calculating the potential insurance losses. ● Use of MS Access, Advanced MS Excel concepts and SQL to fetch and organize the proper data by which to analyze the risk & losses. ● Analyzing and managing the data of the high premium accounts for gaining more insights about the risk associated with it. ● Technologies: Python, Tableau excel, Excel, Lookups, pivot tables, macros, v-lookups SQL, Data Mining. Data Analyst Intern | ABIBA Systems, Bengaluru, India [Jan 2016 - Jul 2016] ● Worked on project “Sentiment analysis on Social Media content” ● Technologies: Python, NLTK, ETL, Twitter API, OLAP, Pivot table, Data Mining, slice and dice in excel, Advanced MS Excel. PROJECTS Transforming Medicare data from SQL (RDBMS) to NoSQL (MongoDB): Improving locality of data for query performance | California State University, East Bay Python, MongoDB, jsonSchema, SQL, AWS ● This design keeps all the frequently accessed data by the queries local to each other due to embeddings, thus reducing disk lookups or joins. ● Data extracted directly from data.cms.gov site in Json format using their API and storing it in AWS shared cluster in python. ● MongoDB Import: Using "mongoimport" to import the json files in MongoDB ATLAS ● JsonSchema applied on the collection to validate documents during insertion in the MongoDB database ● Generated millions of extra data using Python Faker library according to the probability distribution of certain attributes, performing ETL process to consolidate into ONE collection. ● Recorded the performance for each query and compared it with RDBMS query and conclude how MongoDB helps in maintaining data locality when designed correctly and improving certain query performance by more than 300%. ● Technologies: Python, ETL, RDBMS, API Social Media Analytics on Twitter content| Personal Project Python, Machine Learning, Data Analysis & Web design ● Collected tweets using twitter API in python and stored in PostgreSQL database. ● Cleansed the data through ETL process, performed Sentiment analysis with NLTK (Natural language tool kit) in python. ● For better visualization, data were represented in OLAP cube with facts and dimension tables. ● Technologies: Python, Twitter API, OLAP, Adv Excel, Pivot table, Scikit-Learn, Pandas, HTML5, CSS, NLTK. ACHIEVEMENTS ● Received Employee Recognition Award for showing top quality in terms of deliverables in AIG Analytics and Services [2018]
Websites, IT & Software
Analytics
ETL
MongoDB
Python
SQL
30 $
use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
    WONO