SUMMARY

• Nine years of experience in IT Industry as a SQL Server (BI) Developer.
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).
• Strong Transact - SQL (T-SQL) query writing skills (DDL - data definition language and DML - data manipulation language).
• Good understanding of Normalization / De-normalization, Normal Form and database design methodology.
• Strong SQL Server 2000 to SQL Server 2016 developer Skills including writing stored procedures, user defined functions, views, query writing.
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Used Bulk Copy Program (BCP) extensively for flat file import and export operation to / from SQL Server.
• Utilized Data Transformation Services (DTS), SSIS effectively for data migration from external databases like MS Access, AS400, Oracle to SQL Server.
• Scheduling and monitoring daily incremental, alerts, ETL Packages in SQL server.
• Experience in working with Windows servers.
• Knowledge of business intelligence / data warehousing practices and tools (including MS SQL Reporting Services (SSRS) and knowledgeable in SSAS).
• Created Reports with complex formulas and to query the database for business Intelligence.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary and Sub reports, and formatting them.
• Involved in User Acceptance and system testing, bug fixing and documentation for the project.
• Excellent communication, learning, problem solving and conceptual skills. Proficient in technical writing and presentations.

TECHNICAL SKILLS

Databases: MS SQL Server / / 2016, MS-Access 97 / 2000, MySQL 5.02, Sybase 11

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, Business Intelligence Studio, SQL Sentry, LiteSpeed, DTS xChange, IBM I-series client communicator

Languages: C, C++, VB.NET, XHTML, JAVA 1.4.2, UNIX, SQL, T-SQL, XML 1.0

Operating Systems: Win 2003, Win 2000, Win NT 4.0 & XP, UNIX.

Web Servers: IIS 5.0

Other Tools: Erwin 4.0, Microsoft Visual Studio, Microsoft Visio 2003

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP, ETL Tier

SMTP Clients: MS Outlook, Lotus Notes 7

PROFESSIONAL EXPERIENCE

Confidential, Broomfield, CO

SQL Server (BI) Developer

Responsibilities:

• Worked in both Agile, Waterfall, and adaptive SDLC governed development projects.
• Involved in both database design and process design, Code reviews.
• Involved in Project planning meetings per business priorities.
• Involved in requirement collection meetings with stake holders and business analysts.
• Successfully implemented data remediation projects bi directional various Confidential Clientele using common ETL process.
• Developed SSRS reports and Report models based on requirements from users. Extensive use of Report Server Log to find out root cause analysis (RCA) for a report failure additional details.
• Design, development and implementation of ETL processes using SSIS for both data ingestion and report delivery in various report formats and various delivery types. Provided On call support for scheduled process failures on rotation basis.
• Developed Stored Procedures, Triggers, Views and User Defined functions for both reporting and Client server architecture using Transactions and Error capture techniques whenever needed.
• Extensive use of Database tuning advisor along with Query execution plans for efficient code writing.
• Organized Product Demonstration sessions for initial phase of User Acceptance Testing (UAT).
• Development of test scripts, review and validation of Test cases based on user requirements.
• Documentation of release scripts using text and screen shots wherever necessary and kept it to minimum objects as much as can be kept so as to bring down DBA resource time.
• Knowledge transfer to application support team for any product release so as to ease them in working on change requests and future tickets.
• Extensive use of SQL Server Analysis services concepts for tabular and multidimensional models. This is for enterprise data ware house project currently in progress. Kimball methodology and star schema approach implemented to start small and efficient way.
• Worked in both OLTP and OLAP environments.
• TFS and database projects methods of source control and release scripts generation.

Environment: SQL Server /, Oracle 11g,SSIS, SSRS,SSAS Microsoft Visual Studio /2015 with SVN and TFS, Footprints/Track It, C#.NET, SSMS and SSDT.

Confidential, San Diego, CA

SQL Server (BI) Developer

Responsibilities:

• Worked on complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing, deployments and production support activities.
• Extensive interaction with cross team members for gap analysis and product integration activities.
• Along with partial Database design activities, was also involved in coding, unit testing all kinds of SQL Server objects.
• Developed multiple SSIS packages to support Shared Services operated by company to bring in Staff, student, scores and related data from wide variety of sources to support various front end applications, Data ware house and Operational Data store. All SSIS packages were thoroughly configured for supporting multiple environments, alerting and logging purposes.
• Designed and developed SSRS Reports. Most of the reports are configured with subscriptions and snapshot features .All security strategies for report access was designed based on Windows Group(s) or depending front end login.
• Provided Level of Effort (LOE) estimates and Proof of concept (POC) / mockup for all fore mentioned activities
• Review and Validation of Test cases based on user requirements.
• Involved in opening and updating tickets for release management activities with all references to code base, approvals, Go / No Go etc. involved for the deployments.
• Offsite QA and DEV team coordination.

Environment: SQL Server 2008, Windows 2003 Server, SSIS, SSRS, Microsoft Visual Studio with TFS, Nevron Charts, Test track Pro and MOSS (SharePoint)

Confidential, Simi Valley, CA

SQL Server (BI) Developer

Responsibilities:

• Clarified the functional requirements of the project with team and business by referring to the Low Level Design (LLD) document.
• For the Micro Strategy reports developed by BAC, was involved in developing the ETL tier using SSIS to migrate the OLTP data from AS400, SharePoint and other relational databases to SQL Server BI tier.
• Involved in Data Center Migration from Countrywide to Confidential by analyzing and implementing the configuration setting changes of all ETL processes, reporting websites etc.
• ETL component is mainly developed using SSIS to refresh the Dimension and Fact tables incrementally daily.
• Daily Load process was thoroughly configured for all types of logging, alerting and also to report unusual data. Provided On Call support for any failures, changes etc. for the above ETL.
• Involved in migrating Database, reporting and ETL BI Tier from SQL Server 2000 to SQL Server 2005. (In DTS, implemented UDLs for easy Connection management of ETL Upgrade Tier).
• Development and maintenance(handling change requests) of SQL Server Reports(Linked, Tabular types).Provided Excel Pivot reports to Business users to access Data repository i.e. SQL Server Cubes. Also created query based Excel reports on ad hoc basis to support the business. Published SSRS reports to SharePoint site.
• In SSAS, involved in cube processing enhancement by optimizing the dimension usage i.e.
• By changing the cube structure (STAR Schema) to have Private dimensions instead of shared dimension and bring, down time of other cubes by saving time in processing only necessary dimensions.
• Better management of Analysis Service schema by creating linked and virtual cubes.
• Experience in Unit testing and Integration testing methodologies by creating test cases, test scripts and validation scripts using HP Quality center tool.
• Experience in documenting the Release notes, Release scripts in Implementer friendly format; placing them along with necessary executables on corporate level staging environment.

Environment: IBM AS400, SQL Server, Windows 2003 Server, DTS / SSIS, SSRS, Microsoft Visual Studio, DTS xChange and MOSS (SharePoint).

Confidential, Irving, TX

SQL Server Developer / DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005.
• Responsible and for logical and physical design of database.
• Designed and created SQL Database, tables, indexes, and views.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Used SSIS for data population from different sources and create SSIS packages for data conversions and load data from flat files and vice versa.
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Mentor front end users about SQL Queries.
• Written stored procedures to generate the reports for marketing departments etc.
• Generated and automated reports in various formats like PDF / HTML etc.
• Provided on-call support for various projects.
• Performed daily back up of entire database and recovery.