Developer Resume
5.00/5 (Submit Your Rating)
HartforD
SUMMARY:
- Having 6+ year of experience in Software Analysis, Design, Development, Integration, Reporting and Implementation in the Data warehousing.
- Having 4+ year of experience in ETL SSIS, Reporting tool SSRS, Tableau and PPS.
- Having 2 Year of experience in Tableau.
- Created parameter - based worksheet in tableau.
- Extensive experience in implementing SSIS, SSRS using Microsoft Business Intelligence development studio.
- Experience in writing T-SQL queries.
- Hands on experience in developing Packages, deploying and managing Sub reports, drilldown reports, drill through reports.
- Experience to create Geospatial Map, Scatter Plot chart, stories, Parameter in Tableau.
- Experience in Data warehousing concept.
- Created the Reports as per client’s requirements in the form of table, matrix, and list
- Good understanding of Data warehousing concepts, Database system concepts & life cycle model.
- Good experience in working and coordinating with Offshore/Onsite teams and client interaction.
- Proficient and prompt in learning and adapting to new technologies.
- Tuned complex SQL Queries.
- Experience in enhancing and deploying the SSIS Packages from development server to production server.
- Knowledge in SQL Server database including SQL Queries, joins, stored procedure etc.
- Extracted data from R to generate worksheet in Tableau.
TECHNICAL SKILLS:
ETL Tools/ Technologies: SSIS(Sql server integration services),Informatica
Reporting Tools: SSRS
Visualization Tool: Tableau, Power BI
Operating Systems: Windows 2003/ XP/7/8/10
Programming Languages: T-SQL, R
Database: SQL Server 2012,SQL Server 2014
RDBMS: Oracle,Toad,PL/SQL
Tools: SSMS,Toad,BIDS,SSDT
Analytics Tool: Kinaxis, Rapid Response
Domain Knowledge: Healthcare,Manufacturing
Microsoft: MS Office,MS word,PPT
Methodology: Agile
EXPERIENCE:
Developer
Confidential, Hartford
Responsibilities:
- Created Packages in SSIS.
- Maintaining job in Sql Server.
- Involved in the database design of SQL Server Database following data modeling technique.
- Created report and deliver at the time of client requirement.
Developer
Confidential
Responsibilities:
- Developed package with Loading data input files.
- Created output files applied logic.
- Created Event Handling, Error Log in the package.
- Created stores procedure for output files, logging and auditing.
- Created Schemas, Stored Procedure, cursor etc.
- Deployed package using file system approach.
- End to end testing with output file data
- Actively involved in Creating Design/Development of ETL Jobs.
- Optimized the Package and procedure with best approaches.
- Troubleshoot and optimize the query in the best approach in SQL.
- Tuned SQL query using Execution Plan.
- Created Schemas in Data Warehouse.
Developer
Confidential
Responsibilities:
- Created packages following incremental Load approach process.
- Actively involved in Creating Design/Development of ETL Jobs.
- Dealing with Sql object like tables, views and function etc.
- Implement various types of report using SSRS.
- Optimized the query using best approaches followed in the industry.
- Created Job through sql server job agent.
- Scheduling jobs in SSIS.
- Tuned the SQL server query.
- Created Star schema and Snowflake schema using Datawarehouse approach.
Confidential
Technology AnalystResponsibilities:
- Created Charts in Tableau.
- Retrieve the data from R and created forecast worksheet.
- Involved in the database design of SQL Server Database following data modeling technique.
- Created dashboard in tableau.
- Created report and deliver at the time of client requirement.