For the given job description <<Role: Lead Data EngineerLocation: RemoteDuration: Long Term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. Ideal candidate will have the following skills: A successful history of manipulating, processing and extracting value from large, disconnected datasets. Expertise in data modeling, data access and data storage techniques. The candidate should have foundational knowledge of dimensional modeling to build a data warehouse Strong experience building transformational logic using SQL on relational SQL and NoSQL databases. Skills using DBT framework for data transformation is plus Robust programming skills and strong experience with Python to ingest, transform and load the data Experience building and optimizing big data data pipelines, architectures and data sets using tools like Airflow. Experience with AWS cloud services: EC2, EMR, RDS, Redshift>> the resume: <<SummarySalesforce Data migration and SQL BI Developer offering 7 years of leading cross-functional teams and completing projects on-time. Seamlessly manages workload to meet deadlines.
SkillsSalesforce Data migration expertSalesforce Data Loader expertSalesforce AdministratorStrong Microsoft SQL server, MYSQL, SAP skillsSSIS and SSRS expertFluent in TSQL, C, C++, Microsoft ToolsData warehousing and analyticsJIRA and TFSStrong decision makerExcellent communicatorTeam playerSelf-starterActive Directory knowledgeRequirements analysis and design phases
Experience08/2013toCurrentSalesforce Data Engineering ManagerTalent Rover LLC–City,STATE,Managing all data migrations into Talent Rover.Migrate data from multiple sources into Salesforce.Create complex queries to extract data from SQL server and/or MYSQL based on the client's requirement.Created data migration templates to migrate from multiple sources into Salesforce.Manage multiple teams across the globe to complete the implementation life cycle on time.Work with project managers and delivery leads to plan for the sprints and successful implementation of the project.Meet with clients pre sales to provide the quote for data migration after analyzing there data and functionality.Create SSIS package templates for the data migration from similar sources.Complete the data mapping with client and Project manager.Have weekly meeting with multiple clients to update on the progress in the project.Complete the first data migration into Salesforce and guide clients to perform the data validation and track issues.Complete the data validation and get the signoff from client.Plan for the delta or Go-Live load and support the client after go-live.Manage multiple client's implementation in parallel.Use data loader and Workbench to get the data into Salesforce.07/2013to08/2013MS SQL Server / SSIS/SSRS ArchitectEstuate Inc–City,STATE,Create a single data warehouse to hold the data from individual data warehouses.Added a new dimension table and modified the data model of the data warehouse depending on the requirement.Implement ETL solution to extract data from multiple sources into one DW.Designed the high-level design document of the complete process flow.Created a SSIS/ETL package to run across different data warehouses just by changing the connection string of the data source.Designed a SQL agent job that triggers the SSIS package on a schedule.Created reports to compare data between different Data warehouses.Created stored procedures and complex queries to extract the required data from the final data warehouse.Created a web page to implement a simple authentication page for the uses to access the reports.The users can enter the required parameter for each report and execute the report.All the reports were using dynamic parameters, which used to be the input for the stored procedures to fetch the appropriate data.Reports had an option to select single or multiple Data warehouses from the drop down menu.Implemented different types of charts for the graphical representation of the data.Deployed the SSIS/ETL with a one-click deployment to the test and production servers.Deployed reports on to the report server with a simple deployment utility.04/2011to03/2013MS SQL Server / SSIS, SSRS Developer (Technical team lead) / Data ArchitectWorkers' Compensation Insurance Rating Bureau WCIRB–City,STATE,Designed database after analysis of the business requirement.Designed the high-level design document of the complete process flow.Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.Designed development plan and the assigned individual task to team.Worked with an offshore development team, communicating on a daily basis with the team.Designed the complete flow of the file processing.Designed power shell to monitor the file location for the file existence and copy/move to specific location after looking at a character inside the file.Inserted into the tables from the power shell by calling stored procedures.Designed the file processing using the queue (first in first out) concept.Implemented the Queue logic by starting SQL Agent jobs (which pointed to deployed SSIS packages on the integration server).Designed SSIS packages to implement the file processing logic depending on the source of the file.Deployed SSIS packages with a simple one-click deployment to the integration server.Maintained different branches in TFS as development for release 2 and testing for release 1 were together.Resolved the conflicts while merging code in TFS.Deployed different database instances for development, QA, UAT and production from TFS.Designed reports using SSRS for the client as per their specifications.Deployed SSRS on to the report server with an easy way of deployment.Created subscriptions on the deployed reports using report manger.Called those subscriptions using a stored procedure (which fired the report subscription and saved the reports on the file server).Used Database.sqlcmdvars for deploying the database instances giving the flexibility to change the variables used in the deployment.Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.Created the SQL server users and file server users with required permissions by including them in the scripts.Implemented the power shell as a windows service (which is used to monitor the file existence).Implemented matrix tabular and charts while creating the reports using SSRS.Used expressions extensively for hiding textboxes, display labels and hiding charts, matrix and tabular depending on certain conditions.Used parameters, images to retrieve appropriate data from the common data source added globally.Saved images in a binary form in the configuration tables for easy retrieval from SSRS.Implemented Derived column, file system task, conditional split, lookup transformation, OLE DB Command, Data conversion, Data flow, Execute SQL task, Bulk task, Script task, for each loop, Ftp task and other tasks in SSIS.Optimized the loads by adding Indexes wherever needed, dropped and recreated indexes while doing the full loads.Maintained the SQL Server Agent jobs to run depending on the requirement.Used IBM OLE DB connection manager to connect to IBM DB2 database and get some input data to the look up loads.Used Update and Merge statements while working on the Incremental loads.10/2010to04/2011SSIS Technical LeadFocus On The Family–City,STATE,Worked with an offshore development team, communicating on a daily basis with the team.Defined planned and lead the Development tasks.Tracked and reported status, risks and issues to the business.Designed and developed SSIS Packages to import and export data from MS Excel and Flat files.Implemented SSIS packages for data export/import and created maintenance procedures and deployed them to the server.Extensively used SSIS Import/Export Wizard, for performing the ETL operations.Built Control flows and data flow for incremental data loads.Involved in automation of Jobs that perform Incremental load on a timely basis using lookup's and data is delivered in the form of flat files to certain storage points.Used Configuration files for changing variables easily.Worked with SSIS package event handlers, property expressions.Designed the production rollout strategy and migration of assets from environment to environment.Implemented data integrity procedures and logics.Assessed requirement and defined the strategy, technical architecture, implemented plans and delivery of a data warehouse.Made the SSIS code changes depending on the business requirement deployed the changes SSIS packages and propagated them into different environments.Worked on encryption of the file set using PGP and GPG.Designed SSIS packages to send the encrypted file to different vendors using winSCP.Designed SSIS Packages to shrink, backup, encrypt databases.Designed SSIS packages to copy data from historical Server (IBM) to SQL server 2008 using liked servers and open queries.Designed SSIS packages to populate data into ListSelect database for the reporting team.Implemented Audit tasks tables in the databases to maintain logs for the SQL Server Agent jobs.Implemented Full loads (once a week) and Incremental loads (daily) in schedules.Created new Views, Synonyms, Stored Procedures, Functions and Triggers to accomplish the changes in the requirement.Successfully fixed the errors in the SSIS packages and was able to rerun the jobs from the checkpoint files.Worked on different kinds of Transformations like Import Column, Export Column, Lookups, Derived Column, Merge Join, Fuzzy Lookup, ForLoop, ForEachLoop, Conditional Split, Union all, Script component in SSIS as per the client's Requirement.Implemented the changes depending on the new releases into data warehouse, adding new columns, changes in the data types of the columns, new tables etc.Optimized the loads by adding Indexes wherever needed, dropped and recreated indexes while doing the full loads.Used Update and Merge statements while working on the Incremental loads.Maintained the SQL Server Agent jobs to run depending on the requirement.
Education and TrainingExpected inDEC 2009totoMasters of Science:Computer science Computer Science and Electrical EngineeringState University Of New York-New Paltz,NYGPA:Computer science 3.37 Computer Science and Electrical Engineering Created a parallel parking simulator using a scribbler (robot) and Python language via Bluetooth
Princeton College of Engineering and Technology (JNTU)
Hyderabad, Andhra Pradesh, INDIAExpected inMAY 2008totoBachelors:Atomic Energy Central School-Hyderabad,GPA:on Electrical and communication 
Scored 67.67 %
Participated in Crime Scene investigation workshop help during Shaastra 06 (IIT Madras)
Built a street light timing simulator with a group of 4 as my final year project from Wine Yard Technologies
Kakaitya Academy (BIE)
Hyderabad, Andhra Pradesh, INDIA
Intermediate in Mathematics physics and chemistry (MPC)
Scored First division 76.4%.Expected intotoClass X:Central Board of Secondary Education (CBSE)-,GPA:Scored 65.6 %
SkillsActive Directory, Go-Live, automation, backup, C, C++, charts, chemistry, concept, encryption, client, clients, Data conversion, Data migration, data validation, data warehouse, Data warehouses, databases, Database, Data warehousing, delivery, ETL, fetch, Ftp, IBM, DB2, logic, Managing, Mathematics, access, MS Excel, windows, migration, MYSQL, communicator, OLE, DB, page, physics, presenting, progress, Python, QA, reporting, Requirement, Requirements analysis, sales, SAP, Self-starter, servers, shell, scripts, Script, Microsoft SQL server, SQL, SQL Server, strategy, tables, Team player, TSQL, web page, Workbench>>. The result is, 

Fit assessment: Good Fit