SUMMARY:

• Certified Microsoft BI Developer with 6+ years of experience in Report Development, Client Analysis, Database Design and Presentation using SQL Server 2008 R2/2012/2014, SSIS, SSAS and SSRS. Experience in IT as SQL Server Developer and strong work experience on Business Intelligence tools.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, effective functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Technical experience with design and hands - on programming on diverse technology platforms including RDBMS, Cube design & development, ETL engines, BI Scorecards and dashboards.
• Experience in Project Management and Software Development lifecycle including analysis of business function, software design, specifications and software development, testing and documentation, and planning for redesign or transition to another platform.
• Experience with Business Intelligence Development Studio (BIDS)
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Proficient in Resolving Complex Issues and Error Handling in SSIS
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008/2003/XP/Vista, Windows 7/8/10

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer

BI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2010

Languages: T-SQL, HTML, JavaScript, CSS

OLAP Tools: SSAS, SSRS

ETL Tools: SQL Server Integration Services(SSIS), DTS, SQL Server Import/Export Wizard

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

Job Scheduler: SQL Server Agent

Office Tools: MS Word, PowerPoint, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client
• Created and developed Sub-Reports, Drill-down reports, Drill-through reports and Parameterized reports using SSRS.
• Created Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.

Environment: SQL Server 2008 R2, SQL Server 2012, MS Excel, Visual Basic, BIDS.

Confidential

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.
• Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting.
• Performed capacity planning and growth prediction for client audit data.
• Query tuning based on query execution plans, statistics, and profiling.
• Created code-based solution for application error involving composite key manipulation.
• Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning.
• Worked with development teams in the design of physical databases and in modification.
• Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created XML schemas to update user tables and system objects for company data dictionary.

Environment: SQL Server 2008 R2/2012, Visual studio 2008/2012, Microsoft Access, BIDS.

Confidential

SQL SSIS/SSRS ETL Developer

Responsibilities:

• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included ETL of data from flat file and excel sources using SSIS, writing T-SQL backup and create various operational, drill-through and dynamic reports using SSRS.
• Transformed database objects from one server to others server using SSIS.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
• Involved in monitoring and troubleshooting complex packages by using data viewers, grids, debugging and maintenance of ETL packages and its optimization using SQL server best practices.
• Worked as a team member with other technical staff, such as networking to ensure connectivity and compatibility between systems.
• Created SSIS Packages by using advanced tools (i.e. Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill-down reports, Drill-through reports and Parameterized reports using SSRS.
• Troubleshooting of processes, issues, and errors in SSIS Packages to improve performance.

Environment: SQL Server 2008 R2, SQL Server 2012, MS Excel, Visual Basic, BI