SUMMARY

• 8 years of IT experience in Database Development, Design, Analysis, Support of MS SQL Servers 2014/2012/2008/2005 in Development, Testing and Production Environments.
• Expertise in end - to-end implementation of Microsoft Business Intelligence (MSBI) Projects relating to Manufacturing, Retail & Healthcare industries. Excellent analytical, organizational, planning skills with demonstrated abilities in training & working in team towards achieving organizational goals.
• Creation of Data Sources and Data Source Views in SSAS.
• Creation of Dimensions and Cubes and Creating Hierarchies and Relationships among Dimensions and Facts.
• Expertise skills in Calculated Measures, Calculated Members, Dimension Security, Cell Security, Actions, Partitions, Aggregations in SQL Server Analysis Services using Multi-Dimensional Expression (MDX)
• Hands of experience in writing MDX queries and expressions by using functions like IIF, Descendants, PeriodsToDate, Parallel Period, Cross Join, Nonempty, Avg, Ytd, Top Count.
• Experience in developing Table, Sub Reports, Matrix Reports, Drill down reports, and Drill through reports using Sql Server Reporting Services (SSRS).
• Creating solutions, projects and packages and managing them.
• Experience in developing of reports using Tableau.
• Involved in various tasks such as Control Flow(Execute Sql task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join Multicast, Conditional split, Derived column using SSIS.
• Involved in Logging and Exception handling.
• Implemented SCDs while history maintenance in tables.
• Involved in performance tuning at difference levels(Package, Source, Destination and Transformation)
• Implemented checkpoints at package level.
• Strong working experience in Development and Programming using SQLServer.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Experience in development of SQL Queries, Stored Procedures, Functions, Views and Jobs in SQL Server.
• Sturdy experience in interacting independently with the clients, project leads.
• Dedicated team player with superior technical analysis skills.
• Ability to learn and upgrade to the latest technologies according to the organizational needs.
• Scheduled SSRS reports and Sending mails to the different users with using Subscriptions.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Sort, Look Up, Union-All, Merge, Merge Join and Derived Column.
• Creation of Dimensions, Facts, Cubes based on Technical specification document.
• Quick and eager in learning new skills and positive team player

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA.

Senior Developer

Responsibilities:

• Creation of Calculated Measures, Calculated Members, Dimension Security, Cell Security, Actions, Partitions, Aggregations in SQL Server Analysis Services using Multi-Dimensional Expression (MDX)
• Created and manipulated many packages.
• Implemented ETL and business logic with various tasks and transformations.
• Written many customized queries, implemented many performance improvements across packages.
• Populating the Data from different source systems.
• Used chart controls to show trends.
• Analyzing and Understanding the business requirements.
• Creation of Dimensions, Facts, Cubes based on Technical specification document.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Sort, Look Up, Union-All, Merge, Merge Join and Derived Column.
• Created systems for capturing error data in SQL Server using OLE DB Destination.
• Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
• Responsible For SSIS Deployment (File System Deployment and SQL Server Deployment). And Also Providing Roles.
• Deployed SSIS solution in Integration Services catalog database.
• Creating SSRS Reports using SQL Server Database or SSAS database.
• Creating Stored Procedures, Functions.
• Scheduled SSRS reports and Sending mails to the different users with using Subscriptions.
• Creating Reports using SharePoint and deploying the reports in SharePoint Site.

Confidential, Boston, TX.

Software Developer

Responsibilities:

• Analyzing and Understanding the business requirements.
• Creation of Dimensions, Facts, Cubes based on Technical specification document.
• Creation of Calculated Measures, Calculated Members, Dimension Security, Cell Security, Actions, Partitions, Aggregations in SQL Server Analysis Services using Multi-Dimensional Expression (MDX)
• Created and manipulated many packages.
• Implemented ETL and business logic with various tasks and transformations.
• Written many customized queries, implemented many performance improvements across packages.
• Populating the Data from different source systems.
• Used chart controls to show trends.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Sort, Look Up, Union-All, Merge, Merge Join and Derived Column.
• Created systems for capturing error data in SQL Server using OLE DB Destination.
• Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
• Responsible For SSIS Deployment (File System Deployment and SQL Server Deployment). And Also Providing Roles.
• Deployed SSIS solution in Integration Services catalog database.
• Creating SSRS Reports using SQL Server Database or SSAS database.
• Creating Stored Procedures, Functions.
• Scheduled SSRS reports and Sending mails to the different users with using Subscriptions.
• Creating Reports using SharePoint and deploying the reports in SharePoint Site.
• Status reporting from team members on a daily basis and update to project manager on a weekly basis.

Confidential, Boston, TX.

Software Developer

Responsibilities:

• Deployed SSIS solution in Integration Services catalog database.
• Creating SSRS Reports using SQL Server Database or SSAS database.
• Analyzing and Understanding the business requirements.
• Creating Stored Procedures, Functions.
• Creation of Dimensions, Facts, Cubes based on Technical specification document.
• Creation of Calculated Measures, Calculated Members, Dimension Security, Cell Security, Actions, Partitions, Aggregations in SQL Server Analysis Services using Multi-Dimensional Expression (MDX)
• Created and manipulated many packages.
• Implemented ETL and business logic with various tasks and transformations.
• Written many customized queries, implemented many performance improvements across packages.
• Populating the Data from different source systems.
• Used chart controls to show trends.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Sort, Look Up, Union-All, Merge, Merge Join and Derived Column.
• Created systems for capturing error data in SQL Server using OLE DB Destination.
• Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
• Responsible For SSIS Deployment (File System Deployment and SQL Server Deployment). And Also Providing Roles.
• Scheduled SSRS reports and Sending mails to the different users with using Subscriptions.
• Creating Reports using SharePoint and deploying the reports in SharePoint Site.
• Status reporting from team members on a daily basis and update to project manager on a weekly basis.

Confidential

Software Developer

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Involved in developing database objects such as triggers, constraints, indexes and views.
• Used T-SQL to build dynamic stored procedures.
• Managed Database files, transaction log and estimated space requirements.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Responsible for developing automation of maintenance jobs.
• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, jobs and alerts for database.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Interact with Business for requirement collection & Impact analysis
• Design, Development, Integration, Testing & Deployment
• Involved in the entire System study, analysis and Design.
• Managed Database files, transaction log and estimated space requirements.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Involved in the entire System study, analysis and Design.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose
• Involved in developing database objects such as triggers, constraints, indexes and views.