SUMMARY:

• 7 years of IT experience in Analysis, Design, Implementation and Administration of Business IntelligenceSolutions with Microsoft SQL Server2012/2008 with various business domains like Financial, Banking, and Insurance Sector
• Experience in MS SQL Server 2012/2008 with Business Intelligence in SQL Server Reporting Service and SQL Server Integration Service
• Experience in designing Logical and Physical Modeling using ERWIN Tooland ER Studio.
• Experience in High Level Design of ETL - DTS Packages&SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Involved in migration of SSRS reports from SQL 2000 to SQL 2012/2008 and migration with DTS to SSIS 2012/2008
• Proficient in OLTP, OLAP and Data warehousing Design concepts
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Expert in Windows server 2003/2008R2/2012, Microsoft Active Directory, PowerShell, LDAP, DNS, WINS, DHCP
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012/2008
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2008/2012 Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
• Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008)

Database: MS SQL Server 2012/2008/2005, MS Access, Oracle 11g/10g/9i/8i, MySql, PostgreSql, TSQL, PL, SQL, C, Python, LINUX(Shell Scripting)

Web Technologies: HTML, DHTML

Operating Systems: Windows, Unix, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. SQL Server Developer

Responsibilities:

• Interact with business users to acquire specifications for the report and work with business analysts and develop new SSRS reports.
• The SSRS reports will also require feeds from staging tables populated by creating SSIS packages or Informatica workflows.
• Created SSIS Packages to migrate slowly changing dimensions.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Testing of applications for performance, data Integrity
• Generated reports using MS Reporting services.
• Created indexes, constraints and rules on database objects.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Develop Python, Perl, and R programs to query proteomics databases for putative plant kinases and phosphatases using Hidden Markov Model analysis and generate visual reports
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Experienced in using PowerShell command line interface for various operations.
• Experience in supporting multiple Production database servers including backup and recovery, Performance Tuning (DB Tuning).
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Managed data quality effectively, by using data validation scripts in Python.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2008 to SSRS
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Environment: MS SQL Server 2012/2008, SSAS 2008, SSIS 2008,SSRS 2008, T-SQL,ORACLE, PowerShell

Confidential, Dallas, TX

Sr. Datawarehouse/SQL Server Developer

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2008
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Implemented data views and control tools for guaranteed data transformation using SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Successfully deployed SSIS packages with defined security
• Experience writing Shell, Perl and Python scripts to automate the deployments.
• Wrote PowerShell scripts to deploy solution packages, regular maintenance report of the site, which contained the statistics on the site content, list items, and size of the attachments.
• Developed logical database and converted into physical database using Erwin
• Proficiently created Reports based on the requirements using SSRS 2008
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Defined parameters for parameterized Reports using SSRS
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008
• Successfully worked with Report Server and configured to SQL Server 2008
• Created Batch files to run the script in development and production environment
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
• Designed solutions for upcoming new sites and working with deploying features through Stsadm and PowerShell utility.
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
• Build a Python Dictionary for predefines keyword from URI crawling data
• Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
• Tuned SQL queries using execution plans for better performance
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance

Environment: MS SQL Server 2012/2008, SSAS 2008, SSIS 2008,SSRS 2008, PowerShell, T-SQL,ORACLE

Confidential, Princeton, NJ

SQL Server BI (SSIS) Developer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle& Sybase)
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Worked on SSIS transformations like Lookup, Fuzzy grouping, Merge, Union All, Data conversion, Multicast, Pivot & UnPivot
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes with star schema using SQL Server Analysis Services (SSAS)
• Data Reduction was being done using Python and was saved in TSV format.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Querying and manipulating multidimensional cube data through MDX Scripting
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Wrote stored procedures to generate account statements for different types of accounts
• Upgrade enhancements, maintenance, production support and bug fixes for the project

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential, CA

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Install SQL Server 2008 R2/2012 on sandbox, test, alpha, production servers. Installed business intelligence visual studio 2005 on sandbox server.
• Data migration of Jclarety, PDW Data from production servers to sandbox servers.
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive).
• Involved in SSAS (OLAP), data mining and reporting.
• Extensively used Informatica to load data from fixed width and delimited Flat files.
• Implemented ALWAYS ON for DR solution and also implemented ALWAYS ON + Cluster for High Availability & disaster recovery.
• Implemented Transactional Replication for distributing the data across several teams.
• Developed TSQL queries as per the business needs for reporting purposes.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database,
• Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Optimized the SQLs and Informatica mappings which handled millions of records
• Inheriting the developed TSQL script to business intelligence datasets for developing the SSRS reports.
• Involved in publishing/deploying the SSRS reports to data warehouse servers.
• Implemented Error Handling and Logging in Sql Server Integration Services(SSIS)
• SSRS Deployments also developed a utility in VB.net that automates the deployment of reports, moves the reports across the report servers and so on.
• Developed and maintained Central Management Server.
• Developed various policies and administered multiple servers using policy based management.
• Developed, and administered several dash board reports that proved the key information of SQL Server related to I/O, memory, Processes, Waits, and many other things which helps in trouble shoot the issues.
• Worked with tuning the queries using Maximum Degree of parallelism in addressing the issues related to change packet iteration wait types.
• Implemented Kerberos authentication, to fix the "Double Hop" problem while dealing with Linked servers.
• Developed several PowerShell scripts to gather data related to job history, policy evaluation, Backup durations and so on using Central Management Server & SSRS subscriptions.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Developed TSQL Code for archiving data in database, and build a package that automates the whole process of "Backup, restore archive data, backup, and then restore back to the Server".
• Administered the SQL server 2008/2012 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to Users and groups. User management by assigning appropriate permissions to the database users.
• Involved in SSAS Services which includes a group of OLAP and data mining capabilities.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backups, reorganize and rebuild indexes and Update Statistics.
• Performed Backup & Restore and point in time recovery of the databases as per requests.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Involved in the Query optimization and Performance tuning of Stored Procedures, Function and Views.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities and raising service Tickets for upgrading of CPU and memory space.
• Worked on rebuilding the indexes at regular intervals by setting up the fragmentation levels for better performance. Used DBCC commands and Dynamic Management Views

Environment: SQL Server 2008/R2/2012, .NET Frame Work 3.5/4.0, SSAS, Visual Studio 2010/2012, Informatica, ASP.NET, C#.Net, ADO.NET, HTML, DTS, Crystal Reports, SSRS, SSIS, Web Services

Confidential, Dallas, Texas

SQL Server Developer / ETL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Worked with Scalar and Table value User Defined Function as per business requirement
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time
• Wrote Merge Statement to handle insert, update and delete within single statement between source and destination table
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database
• Made dynamic SSIS packages which did data scrubbing, including data validation
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008
• Deployed, configured and managed reports using Report Manager and Report Builder
• Created Cross-Tab and Sub-Report using RDL
• Promoted RDLs to Reporting Service Server
• Used Visual Source Safe (VSS) for version control.

Environment: Microsoft SQL Server, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel.

Confidential, San Ramon, CA

SQL Server / BI Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Visual Basic .Net, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007

Confidential

SQL Server / SSIS /SSRS Developer

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for the purpose of application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.