Consultant - Data Analytics
Systems ltd
Total years of experience :7 years, 6 Months
To make sure successfully execution of ETL (Extract, Transform, Load) process, in order to facilitate user, which help achieving organization goals. Develop new BI report and change in existing report in order to facilitate user.
OBJECTIVE
• Provide access power BI reports to new user and update or delete old user as per
requirements.
• Responsible for all ETL jobs to be completed on time and successfully.
• Responsible for all Power BI data to be completed on time and successfully.
• Responsible for creating / updating SSIS packages according to user requirements.
• Worked on Alteryx ETL for data comparison
• Create & rebuild index. Query Optimization for batter performance.
Involved in designing, developing and deploying SSIS Packages in MS SQL Server
environment using SSIS in Business Intelligence Development Studio (BIDT).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into
data warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion,
Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries
and enhance the performance of databases.
• Developed SSIS Packages for migrating data from Staging Area, XML and text files and
insert into data warehouse. I have knowledge of different ETL tools like SSIS and Data
stage.
Responsible for designing and creating the data warehouse and all related extraction, transformation and
load of data functions in the company. After the groundwork has been arranged, test their designs to
ensure the system runs smoothly. Read and analyze in detail what a business wants to accomplish with its
data, and design the best possible ETL process around those goals
To make sure successfully execution of Data Stage ETL (Extract, Transform, Load) process, in order to
facilitate user, which help achieving organization goals. Develop new BI report and change in existing report
in order to facilitate user.
Key Accountabilities:-
• Implement new business intelligence and data warehouse requirements using SQL, ETL, Business
Intelligence tools, database programming and reporting tools
• Develop, implement, optimize and maintain ETL (extract, transform and load) solutions to bring
new data into data warehouse
• Data analyst skills to determine root cause of problems for data integrity and data quality issues
identified by QA or business report owners.
• Develop, test and deploy various ETL jobs.
• Design and develop ETL mappings and workflows using Data-Stage.
• Provide guidance and recommendation on BI reporting
• Create reports in BI Cognos 10.
• 7/24 on-call support for production systems
• Taking backup and performing restores.
• Daily activities include monitoring the database, checking error logs, checking the drive size and free
space in the data drives, connectivity of the databases