SUMMARY

• Around 7+ years of professional experience in system analysis, design, development and testing in various domains executed in Client/Server and Data warehouse environments.
• Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Hands on experience in designing the database model and maintain referenced relationships for the data integrity.
• Expertise in creating complex Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.
• Experience in monitoring and tuning the SQL server database performance using tools like SQL Profiler, Index tuning wizard and database engine tuning advisor.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages Migration Wizard and knowledge on Storage Management.
• Excellent work experience on creating packages to handle Incremental loads and slowly changing dimensions to update data in data warehouse using SSIS.
• Experience in logging, ErrorHandling, Check Points, and Package Configuration to provide the dynamic flow off data to load data warehouse.
• Expertise in designing Ad-hoc, Drill-Down, Drill-Through, Matrix, Pivot and Tabular reports to match the needs of the end users by interacting directly with Business Analysts.
• Developed various kinds of graphical reports and scorecards/Dashboards to provide the daily/ weekly and monthly reports to provide a better decision making for the current and future years.
• Proficient in deploying reports and creating subscriptions on the report manager and SharePoint site to provide the access to the specific reports to the business users.
• Knowledge in Creating Cubes and dimensions, defining referenced relationships in SSAS, defining granularity within a measure group and drill through actions, generated KPIs and calculations.
• Creating/Modifying/Locking Logins and Users in Sybase Database.
• An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000/XP, Windows 2003 Server, UNIX

Languages: C, C#.Net, VB.Net, XML, HTML, T-SQL, PL/SQL

Databases: MS SQL Server 2000/05/08/12/14, Oracle 9i/10g, MS Access, DB2,SAS

ETL Tools: DTS, SSIS (SQL Server Integration Services),SSDT

Tools: /Utilities: Enterprise Manager, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, SQL Profiler, ER win, Microsoft Office, MS Visio 2003/2007/2010, MS Project.

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008, Actuate Report

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Migrated data from SQL Server 2008 to SQL Server 2014 environment.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Tuned complex SQL Queries.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities.
• Performed regular data consistency, quality and reliability checks.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).

Environment: MS SQL Server 2014/2008R2, SSIS-2012, SSRS, Visual Studio 2012, Red Gate, AgentRansack, VS 2008, PowerShell Scripting.

Confidential, Austin, TEXAS

SQL Developer

Responsibilities:

• Migrated data from the various databases and transformed it by creating SSIS Packages looking at slowly changing dimensions.
• Incorporating business logic to perform ETL operations using SSIS, SQL Loader while converting from web trends to SQL Server.
• Implemented incremental loading as per the daily changes in source database and applied event handlers, checkpoints and error logging on the failure of packages.
• Configured packages to operate them on testing and production environments and scheduled jobs to run the packages and created configuration files to execute package in multiple environments.
• Generated daily, weekly and monthly Ad-hoc reports in SQL Server Reporting Service (SSRS) on the products, cash inflow and the meetings held by the end users.
• Generated analytical reports of market research data and existing customer data using SSRS and reported to the Marketing Department.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reports to the end users.
• Making daily basis reports as per user requirement using MS Reporting Services.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the customer Information.
• Involved in creating Cubes in SSAS (MDX) to generate reports to analyze the data.
• Working with database administrators to ensure available resources, both target and source systems.
• Communicated statuses with data warehouse and business intelligence teams and assisted in resolving data-related problems.
• Master working in OLTP & OLAP environments using SSIS, SSRS and SSAS cubes that include QA, Production and development, implemented and maintained database schema and Entity relationship (ERD) diagrams (using ERWIN) from business requirements.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using SQL Server Analysis Services (SSAS).
• Used SQL server Profiler to apply traces on the stored procedures and queries and rebuild them to improve the performance.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Worked on Actuate Report Development which involves scripting and Actuate Report Server.

Environment: Oracle, Server 2000/2005/2008 Enterprise, BIDS, MSMS, Microsoft Reporting Service(SSRS), SQL Server Integration Services (SSIS), SSAS, Enterprise Manager, Microsoft office share point portal server 2003 .NET, C#, ASP.NET, Red gate, Informatica, SharePoint, BizTalk, VB.Net, BO, AutoSys etc.

Confidential, Omaha, NE

SQL Server Developer

Responsibilities:

• Worked on iteration basis to make sure the deliverables are achieved on time.
• Involved in the meetings with business users to design the business required document for the enhancements proposed.
• Designed, altered the existing schemas to enhance the functionality of the portfolio tracking system.
• Generated Weekly, Monthly and Yearly reports for time reporting systems (TRS).
• Worked on various complex stored procedures on back end to calculate budget data and provide actual and forecast information for all global domains.
• Involved in developing SSIS configuration and developed the SSIS Framework.
• Enhancing the existing functionality to display more qualitative data to the business.
• Worked on enhancing DB scripts for the actuals and forecast budget data screens to determine the flow of money across various global projects.
• Performed the activities on production servers to deploy the changes made during the iteration.
• Coordinated with production support and DBA team in refreshing the existing Database instances from the production servers.
• Provided the data as required for the front-end developers to restructure the existing presence of the UI Screen.
• Capture various metrics of SAS helpdesk tickets
• Conducted analysis and generated tables, listings and graphs using SAS
• Provide SAS the capability to connect with additional datasets.
• Involved on using MS Excel Formulas like Look Up, Conditional, Date and Time, Conversion, text to validate data.

Environment: Microsoft Windows 2003 Advanced Server,SAS, Microsoft SQL Server 2012 Management Studio, Microsoft SQL Server 2000 Enterprise Edition, Microsoft Visual Basic 6.0, Hardware: Compaq ProLiant 8500 Server.

Confidential

SQL Server Developer

Responsibilities:

• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Complex queries and stored procedures to get the updates data from other servers.
• Creating new Database with objects such as tables, views, indexes, triggers etc.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Used Microsoft SQL server 2005 Integration Services to extract data from Flat file, to transform data using data conversion transformation, aggregate transformation and to load the result into fact table dimension.
• Troubleshoot system issues, monitored scheduled jobs and monitoring SQL Server databases.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Environment: SQL Server 2000/2005, SQL, DTS
• Created Database objects including Tables, Triggers and Views.
• Set database access privileges for different users and user groups.
• Involved in programming module screens like Employee, Work Assignment etc.
• Monitoring SQL Server activity through profiler.
• Query tuning and optimization through T-SQL.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database
• Designed database schema validation tool using stored procedures
• Migrating data from Access, Text file to SQL Server through DTS
• Job, Scheduling, batch, alert and E-mail notification setting.
• Tuning and optimizing queries and indexes.

Environment: Windows 2000 Advanced Server, SQL Server 2008R2.

Confidential

SQL Server Developer

Responsibilities:

• Created Database objects including Tables, Triggers and Views.
• Set database access privileges for different users and user groups.
• Involved in programming module screens like Employee, Work Assignment etc.
• Monitoring SQL Server activity through profiler.
• Query tuning and optimization through T-SQL.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database
• Designed database schema validation tool using stored procedures
• Migrating data from Access, Text file to SQL Server through DTS
• Job, Scheduling, batch, alert and E-mail notification setting.
• Tuning and optimizing queries and indexes.

Environment: Windows 2004Advanced Server, SQL Server 2005